package com.situ.water_read.mapper;

import com.situ.water_read.pojo.RdVolume;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.situ.water_user.pojo.UsUser;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author Angel
 * @since 2020-12-01
 */
@Mapper
public interface RdVolumeMapper extends BaseMapper<RdVolume> {

    List<Map> queryarea(Map map);

    List<Map> queryvolume(Map map);

    @Select("select r.VolumeId,r.VolumeIndex,v.VolumeName from RD_Volume v,RD_Read r where r.VolumeId=v.ID and userNo=#{value}")
    public Map queryUserNo(String userNo);

    void updateUserByVolume(UsUser user);
}
